REGISTRODEINGRESOHQ

"192.168.0.1:sipop"

REGISTRODEINGRESOHQ

Descriptions

REGISTRO DE INGRESO DE BODEGA DE HERRAMIENTAS Y EQUIPO

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		ID_REGISTRO_INGRESO		CHAR (8)
		FECHA_DOCUMENTO		DATE
		TIPO_INGRESO		CHAR (2)
		AUTORIZADOPOR		CHAR (3)
		RECIBIDOPOR		CHAR (3)
		DOCUMENTO		CHAR (30)
		TIPODOCUMENTO		CHAR (3)
		FECHA_ENTRADA		DATE
		PROVEEDOR		CHAR (3)
		USER_DIGITADOR		VARCHAR (20)
		NIT_CRED_FISCAL		VARCHAR (14)
		REGISTRON_CRED_FISCAL		VARCHAR (6)
		DATETIME_INSERT		TIMESTAMP

Triggers

Trigger	Type	Active	Position	Description
REGISTRODEINGRESOHQ_BI	Before Insert		0

Indices

There are no indices for table REGISTRODEINGRESOHQ

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PROVEEDOR	INTEG_233	PROVEEDOR	ID_PROVEEDOR	RESTRICT	RESTRICT
TIPOINGRESO	INTEG_234	TIPO_INGRESO	ID_TIPO_INGRESO	RESTRICT	RESTRICT
TIPODOCUMENTO	INTEG_242	TIPODOCUMENTO	ID_TIPO_DOCUMENTO	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table REGISTRODEINGRESOHQ

Definition


CREATE TABLE REGISTRODEINGRESOHQ (
    ID_REGISTRO_INGRESO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    FECHA_DOCUMENTO DATE NOT NULL,
    TIPO_INGRESO CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    AUTORIZADOPOR CHAR (3) CHARACTER SET NONE COLLATE NONE,
    RECIBIDOPOR CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DOCUMENTO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    TIPODOCUMENTO CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    FECHA_ENTRADA DATE NOT NULL,
    PROVEEDOR CHAR (3) CHARACTER SET NONE COLLATE NONE,
    USER_DIGITADOR VARCHAR (20) CHARACTER SET NONE COLLATE NONE,
    NIT_CRED_FISCAL VARCHAR (14) CHARACTER SET NONE COLLATE NONE,
    REGISTRON_CRED_FISCAL VARCHAR (6) CHARACTER SET NONE COLLATE NONE,
    DATETIME_INSERT TIMESTAMP);

ALTER TABLE REGISTRODEINGRESOHQ ADD PRIMARY KEY (ID_REGISTRO_INGRESO);
ALTER TABLE REGISTRODEINGRESOHQ ADD  FOREIGN KEY (PROVEEDOR) REFERENCES PROVEEDOR (ID_PROVEEDOR);
ALTER TABLE REGISTRODEINGRESOHQ ADD  FOREIGN KEY (TIPO_INGRESO) REFERENCES TIPOINGRESO (ID_TIPO_INGRESO);
ALTER TABLE REGISTRODEINGRESOHQ ADD  FOREIGN KEY (TIPODOCUMENTO) REFERENCES TIPODOCUMENTO (ID_TIPO_DOCUMENTO);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.